select res.libressource1, res.libressource2, mov.MATRICULE, mov.DATOUT from RCMOUVNT mov inner join rcressource res on mov.matricule = res.matricule
WHERE DATOUT >= to_date('01-Nov-12', 'DD-MON-YY') AND DATOUT <= to_date('30-Nov-12','DD-MON-YY')